if exists (select 1
            from  sysobjects
           where  id = object_id('bd_schedule_receive')
            and   type = 'U')
   drop table bd_schedule_receive
go
CREATE TABLE [dbo].[bd_schedule_receive](
	[id] [bigint] IDENTITY,
	[user_no] [varchar](50) NULL,
	[user_serial] [bigint] NOT NULL,
	[rq] [nvarchar](7) NOT NULL,
	[d1] [varchar](100) NULL,
	[d2] [varchar](100) NULL,
	[d3] [varchar](100) NULL,
	[d4] [varchar](100) NULL,
	[d5] [varchar](100) NULL,
	[d6] [varchar](100) NULL,
	[d7] [varchar](100) NULL,
	[d8] [varchar](100) NULL,
	[d9] [varchar](100) NULL,
	[d10] [varchar](100) NULL,
	[d11] [varchar](100) NULL,
	[d12] [varchar](100) NULL,
	[d13] [varchar](100) NULL,
	[d14] [varchar](100) NULL,
	[d15] [varchar](100) NULL,
	[d16] [varchar](100) NULL,
	[d17] [varchar](100) NULL,
	[d18] [varchar](100) NULL,
	[d19] [varchar](100) NULL,
	[d20] [varchar](100) NULL,
	[d21] [varchar](100) NULL,
	[d22] [varchar](100) NULL,
	[d23] [varchar](100) NULL,
	[d24] [varchar](100) NULL,
	[d25] [varchar](100) NULL,
	[d26] [varchar](100) NULL,
	[d27] [varchar](100) NULL,
	[d28] [varchar](100) NULL,
	[d29] [varchar](100) NULL,
	[d30] [varchar](100) NULL,
	[d31] [varchar](100) NULL,
	[gly_no] [nvarchar](10) NULL,
	[year] [int] NULL,
	[month] [int] NULL,
PRIMARY KEY CLUSTERED
(
	[user_serial] ASC,
	[rq] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
